/*
 Navicat Premium Data Transfer

 Source Server         : 云数据库
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44-txsql-log)
 Source Host           : sh-cdb-cla83u0y.sql.tencentcdb.com:21059
 Source Schema         : city_server

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44-txsql-log)
 File Encoding         : 65001

 Date: 04/02/2025 23:27:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for office_building
-- ----------------------------
DROP TABLE IF EXISTS `office_building`;
CREATE TABLE `office_building` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `publish_type` varchar(20) NOT NULL COMMENT '发布类型(传统写字楼/联合办公)',
  `rent_type` varchar(20) NOT NULL COMMENT '租售方式(出租/出售)',
  `building_type` varchar(20) NOT NULL COMMENT '写字楼类型(纯写字楼/商业综合体/商务公寓/商务酒店/产业园区)',
  `can_register` tinyint(1) DEFAULT '0' COMMENT '可注册公司(0-否,1-是)',
  `property_nature` varchar(20) DEFAULT NULL COMMENT '写字楼性质(新房/二手房)',
  `building_name` varchar(100) NOT NULL COMMENT '写字楼名称',
  `district_label` varchar(255) NOT NULL COMMENT '区域板块',
  `district` json DEFAULT NULL,
  `address` varchar(200) NOT NULL COMMENT '写字楼地址',
  `building_number` varchar(50) DEFAULT NULL COMMENT '楼栋/塔号',
  `floor` int(11) DEFAULT NULL COMMENT '所在楼层',
  `floor_str` varchar(200) DEFAULT NULL COMMENT '所在楼层_中文',
  `total_floors` int(11) DEFAULT NULL COMMENT '总楼层',
  `room_number` varchar(50) DEFAULT NULL COMMENT '房间号',
  `area` decimal(10,2) DEFAULT NULL COMMENT '建筑面积(㎡)',
  `efficiency` decimal(5,2) DEFAULT NULL COMMENT '得房率(%)',
  `decoration` varchar(20) DEFAULT NULL COMMENT '装修情况(毛坯/简装/精装修/豪华装修)',
  `can_divide` tinyint(1) DEFAULT '0' COMMENT '可分割(0-否,1-是)',
  `facilities` varchar(500) DEFAULT NULL COMMENT '配套设施(水,电,电梯等)',
  `tags` varchar(500) DEFAULT NULL COMMENT '房源标签',
  `property_rights` varchar(20) DEFAULT NULL COMMENT '产权(开发商持有/个人持有/公司持有/其他)',
  `post_url` text,
  `image_url` text,
  `video_url` text,
  `business_name` varchar(255) DEFAULT NULL,
  `business_phone` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `secret_remark` varchar(255) DEFAULT NULL,
  `lng` varchar(255) DEFAULT NULL,
  `lat` varchar(255) DEFAULT NULL,
    `developer` varchar(100) DEFAULT NULL COMMENT '开发商',
    `property_company` varchar(100) DEFAULT NULL COMMENT '物业公司',
    `property_fee` decimal(10,2) DEFAULT '0.00' COMMENT '物业费',
    `ac_fee` decimal(10,2) DEFAULT '0.00' COMMENT '空调费',
    `electricity_fee` decimal(10,2) DEFAULT '0.00' COMMENT '电费',
    `parking_fee` decimal(10,2) DEFAULT '0.00' COMMENT '停车费',
    `subway_info` text COMMENT '地铁信息',
    `bus_info` text COMMENT '公交信息',
    `commercial_facilities` text COMMENT '商超配套',
    `hotel_facilities` text COMMENT '酒店配套',
    `administrative_facilities` text COMMENT '行政配套',
    `project_facilities` text COMMENT '项目配套',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='写字楼信息表';

-- ----------------------------
-- Records of office_building
-- ----------------------------
BEGIN;
INSERT INTO `office_building` (`id`, `publish_type`, `rent_type`, `building_type`, `can_register`, `property_nature`, `building_name`, `district_label`, `district`, `address`, `building_number`, `floor`, `total_floors`, `room_number`, `area`, `efficiency`, `decoration`, `can_divide`, `facilities`, `tags`, `property_rights`, `create_time`, `updated_time`, `post_url`, `image_url`, `video_url`, `business_name`, `business_phone`, `remark`, `secret_remark`, `lng`, `lat`) VALUES (3, '传统写字楼', '出租', '纯写字楼', 1, '新房', '卓越世纪中心', '山东省/青岛市/市北区/商都', '[1, 2, 4, 21]', '龙城路31号', '101', 5, 29, '501', 90.00, 50.07, '毛坯', 0, '电,办公家具', '价格可面议,随时入驻,随时看房', '个人持有', '2025-01-20 03:28:57', '2025-01-20 06:53:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `office_building` (`id`, `publish_type`, `rent_type`, `building_type`, `can_register`, `property_nature`, `building_name`, `district_label`, `district`, `address`, `building_number`, `floor`, `total_floors`, `room_number`, `area`, `efficiency`, `decoration`, `can_divide`, `facilities`, `tags`, `property_rights`, `create_time`, `updated_time`, `post_url`, `image_url`, `video_url`, `business_name`, `business_phone`, `remark`, `secret_remark`, `lng`, `lat`) VALUES (4, '传统写字楼', '出租', '纯写字楼', 1, '新房', '卓越世纪中心', '山东省/青岛市/市北区/辽宁路', '[1, 2, 4, 20]', '青岛市市北区龙城路31号', '3', 0, 39, '0', 104.00, 80.00, '豪华装修', 0, '中央空调,办公家具,宽带,暖气,电,水,电梯', '价格可面议', '个人持有', '2025-01-21 03:32:19', '2025-01-21 03:32:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `office_building` (`id`, `publish_type`, `rent_type`, `building_type`, `can_register`, `property_nature`, `building_name`, `district_label`, `district`, `address`, `building_number`, `floor`, `total_floors`, `room_number`, `area`, `efficiency`, `decoration`, `can_divide`, `facilities`, `tags`, `property_rights`, `create_time`, `updated_time`, `post_url`, `image_url`, `video_url`, `business_name`, `business_phone`, `remark`, `secret_remark`, `lng`, `lat`) VALUES (5, '传统写字楼', '出租', '纯写字楼', 1, '新房', '卓越世纪中心', '山东省/青岛市/市北区/辽宁路', '[1, 2, 4, 20]', '市北区龙城路31', '3号楼', 0, 39, '1207', 134.80, 0.00, '精装修', 0, '水,电梯,暖气,宽带,中央空调', '价格可面议', '个人持有', '2025-01-21 05:18:43', '2025-01-21 05:18:43', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/8319c9f417569963a8b836191b879929.jpg', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/72d2647003ecfcb948a1d9049626d8e6.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/738999e4a9ee1b20fb50c9939b40d6df.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/f1138bce4ef25b559962c723c67565c9.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/dd989198265223ebf92ed34536fb1066.jpg', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/7658aa6f856efb2f900a74ca0f0e3c01.mp4', '', '', '', '', '', '');
INSERT INTO `office_building` (`id`, `publish_type`, `rent_type`, `building_type`, `can_register`, `property_nature`, `building_name`, `district_label`, `district`, `address`, `building_number`, `floor`, `total_floors`, `room_number`, `area`, `efficiency`, `decoration`, `can_divide`, `facilities`, `tags`, `property_rights`, `create_time`, `updated_time`, `post_url`, `image_url`, `video_url`, `business_name`, `business_phone`, `remark`, `secret_remark`, `lng`, `lat`) VALUES (6, '传统写字楼', '出租', '纯写字楼', 1, '新房', '卓越世纪中心', '山东省/青岛市/市北区/辽宁路', '[1, 2, 4, 20]', '市北区龙城路31号', '3号楼', 0, 39, '0', 82.99, 80.00, '精装修', 1, '电梯,宽带,暖气,办公家具', '价格可面议', '个人持有', '2025-01-21 05:23:55', '2025-01-21 05:23:55', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/c284820ada93fc766bfd5f6958f4bd15.jpg', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/40e35fd32aa511c7513d683658bcf0a4.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/3880ba94e4b6d9d5580b3efa213dc663.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/a3a7ca1afa1204a19b8e9639871c4b77.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/c284820ada93fc766bfd5f6958f4bd15.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/d857f111a62fa5158394d29458ecc41b.jpg', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/0c7819df5455464b38df62fd63460383.mp4', '', '', '', '', '', '');
INSERT INTO `office_building` (`id`, `publish_type`, `rent_type`, `building_type`, `can_register`, `property_nature`, `building_name`, `district_label`, `district`, `address`, `building_number`, `floor`, `total_floors`, `room_number`, `area`, `efficiency`, `decoration`, `can_divide`, `facilities`, `tags`, `property_rights`, `create_time`, `updated_time`, `post_url`, `image_url`, `video_url`, `business_name`, `business_phone`, `remark`, `secret_remark`, `lng`, `lat`) VALUES (7, '传统写字楼', '出租', '纯写字楼', 1, '新房', '卓越世纪中心', '山东省/青岛市/市北区/辽宁路', '[1, 2, 4, 20]', '市北区龙城路31号', '3号楼', 0, 39, '0', 242.00, 80.00, '精装修', 1, '水,电,宽带,中央空调', '价格可面议', '个人持有', '2025-01-21 05:30:27', '2025-01-21 05:30:27', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/97b163cc9522c0e0597fef2b8b4e1f8f.jpg', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/5a616d27c71278bb600bbf6a0f3f60d5.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/017d5a948552cfb867ea674bca7a2ec9.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/23b3317dc241f8f3cf9e87b1da26246b.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/97b163cc9522c0e0597fef2b8b4e1f8f.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/873f318e60e4d99ab6a44aba773f03aa.jpg', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/ad95879b6d2c73e04deb5370d771ce62.mp4', '', '', '', '', '', '');
INSERT INTO `office_building` (`id`, `publish_type`, `rent_type`, `building_type`, `can_register`, `property_nature`, `building_name`, `district_label`, `district`, `address`, `building_number`, `floor`, `total_floors`, `room_number`, `area`, `efficiency`, `decoration`, `can_divide`, `facilities`, `tags`, `property_rights`, `create_time`, `updated_time`, `post_url`, `image_url`, `video_url`, `business_name`, `business_phone`, `remark`, `secret_remark`, `lng`, `lat`) VALUES (8, '传统写字楼', '出租', '纯写字楼', 1, '新房', '卓越世纪中心', '山东省/青岛市/市北区/辽宁路', '[1, 2, 4, 20]', '市北区龙城路31号', '', 0, 39, '0', 140.82, 80.00, '精装修', 0, '电,宽带,电梯,暖气', '价格可面议', '个人持有', '2025-01-21 05:34:30', '2025-01-21 05:34:30', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/b8c6eff4362ec9a6a3fc657598d13cb0.jpg', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/466920b60d5155a47b49ed85407c8adb.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/8409275107bd35551b81360c96ea55aa.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/b8c6eff4362ec9a6a3fc657598d13cb0.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/b186bb8fd15a64fa008f575db9a6daf0.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/ba0cdd93b7f1664dd5763b9a9161dbc8.jpg', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/9921a72606ea2bd1b8319423fb0ae7d9.mp4', '', '', '', '', '', '');
INSERT INTO `office_building` (`id`, `publish_type`, `rent_type`, `building_type`, `can_register`, `property_nature`, `building_name`, `district_label`, `district`, `address`, `building_number`, `floor`, `total_floors`, `room_number`, `area`, `efficiency`, `decoration`, `can_divide`, `facilities`, `tags`, `property_rights`, `create_time`, `updated_time`, `post_url`, `image_url`, `video_url`, `business_name`, `business_phone`, `remark`, `secret_remark`, `lng`, `lat`) VALUES (9, '传统写字楼', '出租', '纯写字楼', 1, '新房', '卓越世纪中心', '山东省/青岛市/市北区/辽宁路', '[1, 2, 4, 20]', '市北区龙城路31号', '3号楼', 0, 39, '0', 179.87, 80.00, '精装修', 1, '水,电,电梯,暖气,中央空调,办公家具', '价格可面议', '个人持有', '2025-01-21 05:37:17', '2025-01-21 05:37:17', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/274dc335f4a8e0a29b7b586cb3b53fae.jpg', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/8e8421959ed1abc2307eeda3e82ae59b.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/900ad451f46fe2edb87fbb7561c31b82.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/87502d4c7a946805c0473cec5b69ec14.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/b7ec35c17377c3cd2542cff88869f71f.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/d8a7ad50e8328bb7dd60d331103620f1.jpg,https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/daf1758c0de0a8f525d1a7216fbc94d5.jpg', 'https://diandian-1300713889.cos.ap-shanghai.myqcloud.com/ffe52720d2c5c4bfefdf6cbc5c58ba72.mp4', '', '', '', '', '', '');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
